The SQL Starter Book 1 - SQL DML (The SQL Starter Series) by Lewis Cunningham

Author:Lewis Cunningham [Cunningham, Lewis]
Language: eng
Format: azw3
Publisher: Lewis Cunningham
Published: 2008-11-14T16:00:00+00:00

LAST_NAME FIRST_NAME DEPARTMENT_NAME

-------------------- -------------------- --------------------

Grant Kimberely

Treasury

Corporate Tax

Control And Credit

Shareholder Services

Benefits

Manufacturing

Construction

Contracting

Operations

IT Support

NOC

IT Helpdesk

Government Sales

Retail Sales

Recruiting

Payroll

17 rows selected.

From this query and the result set, I can see that we have only a single employee without a department id but we have 16 departments that contain no employees.

A full outer join cannot be represented in the older where clause join syntax. It is possible to mimic a full outer join using other query methods, though.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.